[dbo].[EventSetupFunctionGroup]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$	EventCode	varchar(15)	15
$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$	FunctionCode	varchar(15)	15
	GroupName	varchar(8)	8
	FunctionOrder	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$

EventCode

varchar(15)

$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$

FunctionCode

varchar(15)

GroupName

varchar(8)

FunctionOrder

int

	Name	Columns	Unique
$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$	PK_EventSetupFunctionGroup	EventCode, FunctionCode
	iWC	GroupName

Name

Columns

Unique

$Cluster Primary Key PK_EventSetupFunctionGroup: EventCode\FunctionCode$

PK_EventSetupFunctionGroup

EventCode, FunctionCode

iWC

GroupName

Name	Columns
FK_EventSetupFunctionGroup_EventSetupGeneral	EventCode->[dbo].[EventSetupGeneral].[EventCode]

Name

Columns

FK_EventSetupFunctionGroup_EventSetupGeneral

EventCode->[dbo].[EventSetupGeneral].[EventCode]

SQL Script

CREATE TABLE [dbo].[EventSetupFunctionGroup]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FunctionCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GroupName] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FunctionOrder] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupFunctionGroup] ADD CONSTRAINT [PK_EventSetupFunctionGroup] PRIMARY KEY CLUSTERED ([EventCode], [FunctionCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[EventSetupFunctionGroup] ([GroupName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupFunctionGroup] ADD CONSTRAINT [FK_EventSetupFunctionGroup_EventSetupGeneral] FOREIGN KEY ([EventCode]) REFERENCES [dbo].[EventSetupGeneral] ([EventCode])
GO